Labels:text | screenshot | document | number | parallel OCR: TABLE 1. OLAP Server Product Evaluation Checklist (2) (3) (4) FEATURE PRODUCT FEATURE FEATURE WEIGHT FEATURES RANK SCORE Database Architecture Capacity Data types Text strings Date: BLOBs Multiuser write access Access to multiple databases Database reorganization Calculations . Hierarchies Structures Functions Navigation Can process data at any level Time Understands first and last period in an aggregate period Year-to-date Moving averages Moving totals Models ·Auditing and debugging Financial functions Marketing functions Algebraic functions Automatic ordering Simultaneous equations Dimension Transformations . "Tables, program code" Database recalculation Streaming calculations Query Language . Subsets based on data values Subsets based on hierarchies Subsets based on models Subsets based on time dimension Sorts children of a parent within their parent Heterogeneous granularity Back-End Integration . Data loading Reads legacy data Can select data directly from an RDBMS Can directly read spreadsheets Can specify the range of spreadsheet cells to be read Provides logging of rejected records Manages dimension domains Externally maintains hierarchy parentage relationships Can decode a field value in a data source into a dimension member SQL drill-through Supported through embedded SQL Maps the data warehouse and OLAP server dictionaries Provides administrative tools to manage dictionary mapping
